package constant.milk.cashbook.apt;

import java.util.HashMap;

import android.content.Context;
import constant.milk.cashbook.database.DbAdapter;
import constant.milk.cashbook.database.DbInsertQuery;

public class SeoulSetting
{
	private DbInsertQuery insertQuery;
	
	public SeoulSetting(Context context, DbAdapter db)
	{
		insertQuery = new DbInsertQuery(context, db);
	}
	
	public void Setting() throws Exception
	{
		setData("도봉구", "371", "255");
		setData("노원구",	"406", "280");
		setData("강북구",	"321", "220");
		setData("은평구",	"451", "315");
		setData("종로구",	"594", "390");
		setData("성북구",	"435", "319");
		setData("동대문구", "447",	"321");
		setData("중량구",	"400", "283");
		setData("서대문구", "438",	"320");
		setData("중구	", "501", "343");
		setData("성동구",	"598", "413");
		setData("광진구",	"507", "349");
		setData("마포구",	"580", "429");
		setData("용산구",	"756", "417");
		setData("강서구",	"440", "321");
		setData("양천구",	"579", "384");
		setData("구로구",	"399", "279");
		setData("영등포구", "549",	"347");
		setData("동작구",	"556", "403");
		setData("금천구",	"291", "195");
		setData("관악구",	"450", "318");
		setData("서초구",	"902", "545");
		setData("강남구",	"1037",	"578");
		setData("송파구",	"735", "447");
		setData("강동구",	"547", "336");
	}
	
	private void setData(String name, String meib, String junse) throws Exception
	{
		HashMap<String, String> map = new HashMap<String, String>();
		
		map.put("title", "서울특별시");
		map.put("name", name);
		map.put("meib", meib);
		map.put("junse", junse);
		
		insertQuery.setAptData(map);
	}
}
